/*
 Navicat Premium Data Transfer

 Source Server         : 日常
 Source Server Type    : SQL Server
 Source Server Version : 12002000
 Source Host           : 127.0.01:1433
 Source Catalog        : DailyApp
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 12002000
 File Encoding         : 65001

 Date: 21/01/2025 20:49:04
*/


-- ----------------------------
-- Table structure for __EFMigrationsHistory
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[__EFMigrationsHistory]') AND type IN ('U'))
	DROP TABLE [dbo].[__EFMigrationsHistory]
GO

CREATE TABLE [dbo].[__EFMigrationsHistory] (
  [MigrationId] nvarchar(150) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ProductVersion] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[__EFMigrationsHistory] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of __EFMigrationsHistory
-- ----------------------------
INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241005024819_sqf1005', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241005025604_sqf100501', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241006091435_sqf1006', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241204073451_sqf1204', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241204074211_sqf120401', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241207021215_sqf1207', N'6.0.33')
GO

INSERT INTO [dbo].[__EFMigrationsHistory] ([MigrationId], [ProductVersion]) VALUES (N'20241211130925_sqf1211', N'6.0.33')
GO


-- ----------------------------
-- Table structure for AccountInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[AccountInfo]
GO

CREATE TABLE [dbo].[AccountInfo] (
  [AccountId] int  IDENTITY(1,1) NOT NULL,
  [Name] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Account] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Pwd] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[AccountInfo] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of AccountInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[AccountInfo] ON
GO

INSERT INTO [dbo].[AccountInfo] ([AccountId], [Name], [Account], [Pwd]) VALUES (N'1', N'龙马', N'longmaNew', N'123')
GO

INSERT INTO [dbo].[AccountInfo] ([AccountId], [Name], [Account], [Pwd]) VALUES (N'2', N'龙马', N'longma123', N'c26be8aaf53b15054896983b43eb6a65')
GO

INSERT INTO [dbo].[AccountInfo] ([AccountId], [Name], [Account], [Pwd]) VALUES (N'3', N'龙马', N'longma', N'e10adc3949ba59abbe56e057f20f883e')
GO

INSERT INTO [dbo].[AccountInfo] ([AccountId], [Name], [Account], [Pwd]) VALUES (N'4', N'沈权风', N'sqf', N'e10adc3949ba59abbe56e057f20f883e')
GO

SET IDENTITY_INSERT [dbo].[AccountInfo] OFF
GO


-- ----------------------------
-- Table structure for MemoInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[MemoInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[MemoInfo]
GO

CREATE TABLE [dbo].[MemoInfo] (
  [MemoId] int  IDENTITY(1,1) NOT NULL,
  [Title] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Content] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateTime] datetime2(7)  NOT NULL,
  [AccountId] int  NULL
)
GO

ALTER TABLE [dbo].[MemoInfo] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of MemoInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[MemoInfo] ON
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'1', N'会议一', N'确立项目需求', N'2024-12-11 21:13:00.0000000', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'4', N'会议二', N'确立项目计划', N'2024-12-11 21:13:00.0000000', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'5', N'swagger测试', N'测试通过', N'2024-12-12 11:58:25.5141123', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'6', N'辅导孩子功课', N'今天辅导孩子功课', N'2024-12-12 12:06:50.7764668', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'8', N'显示', N'you BUG', N'2024-12-12 18:54:09.8726548', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'9', N'测试', N'测试内容', N'2024-12-13 10:05:03.5230197', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'11', N'会议三', N'会议三内容', N'2024-12-14 10:39:32.0088636', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'12', N'2222+', N'3333+', N'2024-12-14 17:39:07.0429078', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'16', N'备忘名1', N'内容12', N'2024-12-14 21:43:01.9455371', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'19', N'1111', N'22222', N'2024-12-26 18:51:45.0321211', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'20', N'1', N'2', N'2024-12-26 18:52:34.6546544', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'21', N'11', N'22', N'2024-12-26 18:53:56.1271308', NULL)
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'22', N'23423', N'erwtwertwer', N'2024-12-26 18:54:52.8938621', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'27', N'111gai', N'2222gai', N'2024-12-26 19:14:47.4156860', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'28', N'1？', N'121212', N'2024-12-28 09:38:46.6014355', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'29', N'我的备忘录', N'内容', N'2024-12-28 17:19:52.4832714', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'30', N'被我', N'1', N'2024-12-28 17:21:17.2067332', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'31', N'明去图书馆看书', N'如题', N'2024-12-28 17:23:21.7602420', N'4')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'32', N'1212', N'22132', N'2024-12-28 19:10:16.7241120', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'33', N'1112', N'222', N'2024-12-28 19:15:18.7904416', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'34', N'完结', N'123', N'2024-12-28 19:18:58.1680042', N'3')
GO

INSERT INTO [dbo].[MemoInfo] ([MemoId], [Title], [Content], [CreateTime], [AccountId]) VALUES (N'36', N'儿童委任他为人', N'儿童委任他为人', N'2024-12-28 19:53:46.1696083', N'3')
GO

SET IDENTITY_INSERT [dbo].[MemoInfo] OFF
GO


-- ----------------------------
-- Table structure for WaitInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[WaitInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[WaitInfo]
GO

CREATE TABLE [dbo].[WaitInfo] (
  [WaitId] int  IDENTITY(1,1) NOT NULL,
  [Title] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Content] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Status] int  NOT NULL,
  [CreateTime] datetime2(7)  NOT NULL,
  [AccountId] int  NULL
)
GO

ALTER TABLE [dbo].[WaitInfo] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of WaitInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[WaitInfo] ON
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'1', N'待办事项一', N'下班记得买菜', N'1', N'2024-12-07 10:00:00.0000000', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'2', N'待办事项二', N'辅导孩子作业', N'1', N'2024-12-07 10:00:00.0000000', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'3', N'待办事项三', N'拖地', N'1', N'2024-12-07 10:00:00.0000000', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'4', N'龙马swagger测试标题新', N'龙马swagger测试内容新', N'1', N'2024-12-09 11:46:20.8125126', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'5', N'龙马swagger已完成', N'龙马swagger内容', N'1', N'2024-12-09 11:49:01.4283816', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'6', N'WPF测试', N'WPF测试内容', N'1', N'2024-12-09 12:15:44.5097347', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'7', N'WPF测试已完成', N'WPF测试已完成内容', N'1', N'2024-12-09 12:16:33.6523112', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'8', N'测试通知标题', N'测试通知内容', N'0', N'2024-12-09 12:28:52.2038445', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'9', N'111', N'222', N'1', N'2024-12-09 12:32:31.2400674', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'11', N'特殊', N'PC', N'1', N'2024-12-09 21:28:09.7552597', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'14', N'特瑞特人人涛涛涛涛', N'谔谔二人突然', N'0', N'2024-12-09 21:40:09.8627601', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'17', N'亲近', N'请假！', N'0', N'2024-12-09 21:43:08.4033422', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'18', N'ceshi', N'测试1', N'0', N'2024-12-09 22:42:02.2133557', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'19', N'惊叹国际', N'今天过节', N'0', N'2024-12-11 12:02:56.2210418', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'20', N'测试', N'测试内容', N'0', N'2024-12-13 10:05:19.1341381', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'23', N'右侧添加待办', N'待办内容', N'0', N'2024-12-13 20:13:26.5105685', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'24', N'右侧添加待办', N'待办内容', N'0', N'2024-12-13 20:16:19.9953494', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'25', N'右侧添加待办', N'待办内容', N'0', N'2024-12-13 20:16:35.5478297', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'26', N'右侧待办事项', N'待办', N'0', N'2024-12-13 20:18:27.8505257', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'27', N'右侧待办完成', N'完成', N'1', N'2024-12-13 20:19:22.9059925', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'29', N'8888', N'8888', N'0', N'2024-12-14 17:46:10.4375010', NULL)
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'30', N'题目', N'222', N'1', N'2024-12-14 17:58:47.8021541', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'31', N'今天完结', N'666', N'0', N'2024-12-14 21:49:30.6287185', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'33', N'带v吧？', N'拜拜', N'0', N'2024-12-26 23:10:36.4483929', N'3')
GO

INSERT INTO [dbo].[WaitInfo] ([WaitId], [Title], [Content], [Status], [CreateTime], [AccountId]) VALUES (N'34', N'28测试', N'11', N'0', N'2024-12-28 09:41:46.8250531', N'3')
GO

SET IDENTITY_INSERT [dbo].[WaitInfo] OFF
GO


-- ----------------------------
-- Primary Key structure for table __EFMigrationsHistory
-- ----------------------------
ALTER TABLE [dbo].[__EFMigrationsHistory] ADD CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY CLUSTERED ([MigrationId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for AccountInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[AccountInfo]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table AccountInfo
-- ----------------------------
ALTER TABLE [dbo].[AccountInfo] ADD CONSTRAINT [PK_AccountInfo] PRIMARY KEY CLUSTERED ([AccountId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for MemoInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[MemoInfo]', RESEED, 36)
GO


-- ----------------------------
-- Primary Key structure for table MemoInfo
-- ----------------------------
ALTER TABLE [dbo].[MemoInfo] ADD CONSTRAINT [PK_MemoInfo] PRIMARY KEY CLUSTERED ([MemoId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for WaitInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[WaitInfo]', RESEED, 34)
GO


-- ----------------------------
-- Primary Key structure for table WaitInfo
-- ----------------------------
ALTER TABLE [dbo].[WaitInfo] ADD CONSTRAINT [PK_WaitInfo] PRIMARY KEY CLUSTERED ([WaitId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

